HW#4 --- last modified January 01 1970 00:00:00..

Solution set.

Due date: Apr 17

Files to be submitted:
  ch7.doc
  ch8.sql
  ch8.log

Purpose: To get some experience with the Relational Model and Algebra. To use SQL in a more extensive manner.

Specification:

Do problems 7.19, 7.25 and submit them in ch7.doc. Then do 8.16 and 8.17. For the problems in Ch 8, actually create in Oracle the database in Fig 1.2 and try out your inserts, updates, and queries on this database. The file ch8.sql should contain all the SQL needed to create the DB in figure 1.2 (no sqlldr this time and you should have all the constraints you can think of for the table's) together with each of the operations in 8.16 and 8.17. ch8.log should be a file containing a session where you run your ch8.sql. You can use either script from Unix or SPOOL in SQLPLUS to show this session.

Point Breakdown